Use BD_SYS_ATENCIONES
Go
Create Procedure dbo.GRMaeRequerimiento_Obtener(
   @iNumReq int
)
As
Begin

   Select 
      a.iNumReq,
      a.iCodUsuReg,      
      a.dtFecReq,
      a.vHorReq,
      a.iCodEstReq,
      IsNUll(a.vObsReq,'') as vObsReq,
      a.bAprobado,
      a.iCodUsuApro,
      a.dtFecApro,
      a.iCodUsuAte,
      a.dtFecAte,
      IsNull(a.vObsAte,'') as vObsAte,
      a.iCodUsuA,
      a.vNomTer,
      a.dtFecAct
   From GRMaeRequerimiento a(Nolock)
   Where a.iNumReq = @iNumReq
   
End